//wap to call procedure with parameter: 


import java.sql.*;
import java.util.Scanner;
class JdbcDemo32 {

	public static void main(String[] args) throws Exception {
		Class.forName("oracle.jdbc.driver.OracleDriver");
		Connection cn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","oracle");
		CallableStatement cs=cn.prepareCall("{call update_sal1(?,?)}");
		Scanner scan=new Scanner(System.in);
		System.out.println("input emp no");
		int eno = scan.nextInt();
		System.out.println("input updated salary");
		float s = scan.nextFloat();
		cs.setInt(1, eno);
		cs.setFloat(2, s);
		cs.execute();
		cs.close();
		cn.close();
		// TODO Auto-generated method stub

	}

}
